﻿CREATE TABLE [dbo].[Stock_Out] (
    [Gno]      INT        NOT NULL,
    [Pno]      INT        NOT NULL,
    [Outprice] REAL       NULL,
    [Outnum]   INT        NULL,
    [Outdate]  NCHAR (10) NULL,
    PRIMARY KEY CLUSTERED ([Gno] ASC, [Pno] ASC),
    FOREIGN KEY ([Pno]) REFERENCES [dbo].[Provider] ([Pno]) ON DELETE CASCADE,
    FOREIGN KEY ([Gno]) REFERENCES [dbo].[Goods] ([Gno]) ON DELETE CASCADE
);

